/*-+-*****************************************************************************
 Copyright (C) 2009-2012 Oceanside Software Corporation (R)
 Dallas, Texas

 Author       : Jason T. Brower
 Purpose      : This file is part of a point-of-sale software package
                originally written for Table-Service Restaurants.
              
 Date         : July 8th of 2012
              
 History      : The application that this software file belongs to was 
                written over a 3-Year period.  The first version was written
                in C# .Net 3.5 using Windows Forms.  Being new to .Net at
                the time, I soon learned of Windows Presentation Foundation,
                liked the graphics capabilities and databinding so I
                migrated to WPF.  When the .Net 4.0 framework was released
                the application was migrated from 3.5 to 4.0. Now today,
                .Net 4.5 RC is out and I was already in process of migrating
                before I made this public.
                
Excuse Me     : Please excuse the coding style, it is not representative of
                my typical work.  During the three years I was under a very
                tight budget, constantly running out of funding and was 
                working 18 hour days hyped up on 5-Hour Energy.  The 
                design is not textbook.  It is monolythic because of
                previous issues I will not get into.  There are few comments
                in the code and the ones that are there may be incorrect.
                
What it is not: This is not the exact version that I took through PA-DSS 2.0
                nor is it the exact version running at my customer sites.
                I removed some details for security purposes including some
                encryption algorithms.  The reporting was removed because
                I was including a third party library that cannot be 
                published with this Open Source.
                
What it is    : This application has been running at high volume restaraunts
                for over a year.  It never freezes, crashes or does anything
                unexpected.  So long as it is built, installed and configured
                correctly, it is a strong system that we can all enhance.

Contact       : Please note that I can no longer work for free.  However, you
                can reach me at information@oceansidesw.com.                                                      

*********************************************************************************/
using System;
using System.Linq;

#if _LOCALDB
  using Oceanside.LocalDB;
#else
using Oceanside.RemoteDB;
#endif

#if _LOCALDB
  namespace Oceanside.LocalDB
#else
namespace Oceanside.RemoteDB
#endif
{
    /// <summary>
    /// Access levels that are assigned to users and control security rights and access.
    /// </summary>
    public partial class DAYPART
    {
        #region Public Functions
        /// <summary>
        /// 
        /// </summary>
        /// <returns></returns>
        public override string ToString()
        {
            if (this.Name != null)
                return this.Name;
            else
                return "";
        }


        public static DAYPART GetCurrDaypart(DominicaEntities objectContext)
        {
            DAYPART daypart = null;
            try
            {
                DateTime rightNow = DateTime.Now;

                var q = from DAYPART in objectContext.DAYPARTS
                        where DAYPART.IsDeleted == false orderby DAYPART.DaypartOrdinal descending
                        select DAYPART;

                if (q.Any())
                {
                    foreach (DAYPART dp in q)
                    {
                        if (Functions.IsInBetweenTimeFrame(DateTime.Now, dp.StartTime, dp.EndTime))
                        {
                            daypart = dp;
                        }
                    }
                }
                if (daypart == null)
                {
                    var q2 = from DAYPART in objectContext.DAYPARTS
                             where DAYPART.IsDeleted == false && DAYPART.IsDefault == true
                             select DAYPART;

                    if (q2.Any())
                    {
                        daypart = q2.First();
                    }
                    else
                    {
                        var q3 = from DAYPART in objectContext.DAYPARTS
                                 select DAYPART;
                        if (q3.Any())
                        {
                            daypart = q3.First();
                        }
                    }
                }
            }
            catch (Exception ex)
            {
                Constants.ErrorDispatcher.Notify(Error.EType.E_PLACEHOLDER, ex);
            }
            return daypart;
        }
        public static DAYPART GetDefaultDaypart(DominicaEntities objectContext)
        {
            try
            {
                var q2 = from DAYPART in objectContext.DAYPARTS
                         where DAYPART.IsDeleted == false && DAYPART.IsDefault == true
                         select DAYPART;

                if (q2.Any())
                {
                    return q2.First();
                }
            }
            catch (Exception ex)
            {
                Constants.ErrorDispatcher.Notify(Error.EType.E_PLACEHOLDER, ex);
            }
            return null;
        }
        #endregion
    }
}
